# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2023年03月15日
"""
import openpyxl

myBook=openpyxl.load_workbook('订单表.xlsx',data_only=True)
mySheet1=myBook['全部订单表']
mySheet2=myBook['已出库订单表']

mySheet3=myBook.copy_worksheet(mySheet1)
mySheet3.title='未出库订单表'
while mySheet3.max_row>1:
	mySheet3.delete_rows(2)

myList1=list(mySheet1.values)[1:]
myList2=list(mySheet2.values)[1:]
for myRow in myList1:
	if myRow not in myList2:
		mySheet3.append(myRow)

myBook.save('结果表-订单表.xlsx')

